Example: Correlation

A new dataset will be created of the correlation matrix, showing the relationship between the dataset fields. The correlation is calculated using either an index or time as for the calculation.

The calculated correlation coefficients will always be between -100% and +100%, indicating the following:

• +100% = perfect positive correlation,

• 0 = no correlation at all, and

• −100% =  perfect negative correlation.

The closer the coefficient is to 100%, the greater the correlation between the two fields.

 

Rows containing empty or null values cannot be used in the correlation calculations. This operation will only use the rows that contain valid values in the specified fields for the correlation calculations. A value of zero is a valid value. One option is to precede using this operation with the "Replace empty values" operation.

Example 1: Index based correlation

Initial dataset:

Configuration:

Correlation base selection page: Index based

Correlation field selection page:

1. • Field1

   • Field2

   • Field3

Resulting dataset:

Example 2: Time based correlation

Initial dataset:

Configuration:

Correlation base selection page : Time based - using timestamp Field4

Correlation field selection page:

1. • Field1

   • Field2

   • Field3

Resulting dataset:

---

Related topics:

• Overview of operation: Correlation

• Configuring operation: Correlation

• Overview of operations

• Technical comparison of operations

• Overview of icons